CREATE PROCEDURE [KS_ShopItemAdd]
  @channelid int,
  @classid int,
  @title nvarchar(255),
  @titlefontcolor varchar(50),
  @producttype int,
  @proid nvarchar(100),
  @barcode nvarchar(150),
  @unit nvarchar(50),
  @weight float,
  @intro nvarchar(255),
  @defaultpic nvarchar(255),
  @bigphoto nvarchar(255),
  @keytags varchar(255),
  @hits int,
  @adddate datetime,
  @attribute varchar(255),
  @priority varchar(100),
  @inputer varchar(100),
  @verify int,
  @refreshtf int,
  @templatefile varchar(255),
  @filename varchar(255),
  @attributecart varchar(255),
  @price money=0,
  @price_member money=0,
  @score money=0,
  @groupprice int =0,
  @ischangebuy int =0,
  @changebuyneedprice money=0,
  @changebuypresentprice money=0,
  @islimitbuy int=0,
  @limitbuytaskid int=0,
  @limitbuyprice money=0,
  @limitbuyamount int=0,
  @taxtf tinyint=0,
  @tax float=0,
  @amount int =0,
  @alarmnum int =0,
  @minordernum int=0,
  @maxordernum int =0,
  @seotitle varchar(255),
  @seokeywords varchar(255),
  @seodescription varchar(255),
  @attachmentcharge int=0,
  @attachmentchargeonce int=0,
  @turnurl varchar(255),
  @isscorechange int=0,
  @changescore int=0,
  @template3gfile varchar(255),
  @showon3g int=0,
  @itemid int output
 AS
  INSERT INTO [KS_ProductList]

(channelid,classid,title,titlefontcolor,producttype,proid,barcode,unit,weight,intro,defaultpic,bigphoto,keytags,hits,adddate,attribute,priority,inputer,verify,refreshtf,templatefile,filename,attributecart,price,price_member,score,groupprice,ischangebuy,changebuyneedprice,changebuypresentprice,islimitbuy,limitbuytaskid,limitbuyprice,limitbuyamount,taxtf,tax,amount,alarmnum,minordernum,maxordernum,seotitle,seokeywords,seodescription,attachmentcharge,attachmentchargeonce,turnurl,isscorechange,changescore,template3gfile,showon3g) 
  VALUES

(@channelid,@classid,@title,@titlefontcolor,@producttype,@proid,@barcode,@unit,@weight,@intro,@defaultpic,@bigphoto,@keytags,@hits,@adddate,@attribute,@priority,@inputer,@verify,@refreshtf,@templatefile,@filename,@attributecart,@price,@price_member,@score,@groupprice,@ischangebuy,@changebuyneedprice,@changebuypresentprice,@islimitbuy,@limitbuytaskid,@limitbuyprice,@limitbuyamount,@taxtf,@tax,@amount,@alarmnum,@minordernum,@maxordernum,@seotitle,@seokeywords,@seodescription,@attachmentcharge,@attachmentchargeonce,@turnurl,@isscorechange,@changescore,@template3gfile,@showon3g)
select @itemid=@@identity
